﻿CREATE TABLE [dbo].[FoodServings] (
    [FoodServingID]          INT             IDENTITY (1, 1) NOT NULL,
    [FoodID]                 INT             NOT NULL,
    [Description]            NVARCHAR (MAX)  NULL,
    [MetricServingAmount]    DECIMAL (18, 6) NULL,
    [MetricServingUnit]      NVARCHAR (MAX)  NULL,
    [NumberOfUnits]          DECIMAL (18, 6) NULL,
    [MeasurementDescription] DECIMAL (18, 6) NULL,
    [NutritionInfoID]        INT             NULL,
    [DateTimeAdded]          DATETIME        NOT NULL,
    [DateTimeUpdated]        DATETIME        NOT NULL
);

